MONTH

Returns the month (1-12) from a date value.

Syntax

MONTH(date)

Arguments

• date: The date from which to extract the month.

Example

MONTH("2025-03-02") → Returns 3
MONTH(A1) → Returns the month from the date in cell A1